package test;

public class PopulateData {

	
	private PopulateData(){};
	
	
	//Users
	public static String[][] USER_INJECT = 
		{
		{"INSERT INTO trackvoodoo.user (name, loginName, password, joinDate, avatar, adminUser) VALUES (?, ?, ?, CURDATE(), ?, ?)"},
		{"admin", "admin", "admin", "avatarLoc", "True"}, //1
		{"joe humphries", "joe90", "staff123", "avatarLoc","False"}, //2
		{"mike atkins", "mike", "staff123", "avatarLoc","False"}, //3
		{"john humphries", "john", "staff123", "avatarLoc","False"}, //4
		{"paul raby", "paulr", "staff123", "avatarLoc","False"}	 //5
		};
		
	//News
	public static String[][] NEWS_INJECT =
		{
		{"INSERT INTO trackvoodoo.newsitem (dateCreated, header, story, picture) VALUES (CURDATE(), ?, ?, ?)"},
		{"Lotus track day","A new lotus only track day", "pic"},
		{"Drive a F1","A Chance to drive an f1 car","pic"}
		};
	
	//Track
	public static String[][] TRACK_INJECT =
		{
		{"INSERT INTO trackvoodoo.track (name, description) VALUES (?, ?)"},
		{"Castle Combe","Wiltshire based race track"}, //1
		{"Hullavington","Wiltshire based airport day"},//2
		};
	
	public static String[][] TRACKPICTURES_INJECT =
		{
		{"INSERT INTO trackvoodoo.trackpictures (trackRef, trackOverview, location, picture) VALUES (?,?,?,?)"},
		{"1","overViewPic1","locationPic1","pic1"},
		{"1","overViewPic2","locationPic2","pic2"},
		{"2","overViewPic3","locationPic3","pic3"}
		};
	
	public static String[][] TRACKDAYS_INJECT =
		{
		{"INSERT INTO trackvoodoo.trackdays (trackRef, date, description) VALUES (?, CURDATE(),?)"},
		{"1","Lotus day"},
		{"1","Renault Sport day"},
		{"2","Open day"},
		{"2","RWD day"}
		};
	
	//Achievements
	public static String[][] ACHIVEMENT_INJECT =
		{
		{"INSERT INTO trackvoodoo.achivement (internalName, description, instant, count, points, notJpg, gotJpg) VALUES (?,?,?,?,?,?,?)"},
		{"ONEDAY","Attend one track day","1","0","10","notJpg","gotJpg"},
		{"TENDAY","Attend ten track days","1","0","10","notJpg","gotJpg"},
		{"TRACKCAR","Have a track car","1","0","20","notJpg","gotJpg"},
		{"GIVERIDE","Give 20 track day rides","0","20","40","notJpg","gotJpg"}
		};

	
	//Car information....	
	public static String[][] CAR_INJECT =
		{
		{"INSERT INTO trackvoodoo.car (make, model, description, userRef) VALUES (?,?,?,?)"},
		{"Renault","Clio","Clio Sport 172","2"}, //ref 1
		{"BMW","328","bmw track car","2"} // ref2
		};
	
	public static String[][] CAR_PICTURES_INJECT =
		{
		{"INSERT INTO trackvoodoo.carpictures (carRef, userRef, pictureLocation, pictureDescription) VALUES (?,?,?,?)"},
		{"1","2","clioPic","Clio cup 172 pic"},
		{"2","2","BmwPic","BMW Track pic"}
		};
	
	public static String[][] CAR_COMMENTS_INJECT =
		{
		{"INSERT INTO trackvoodoo.carcomments (carRef, poster, comment, date) VALUES (?,?,?,CURDATE())"},
		{"1","joe90","Nice car"},
		{"1","mike","Crap car"},
		{"2","mike","Crap track car"}
		};
		
	public static String[][] CAR_MODIFICATION_INJECT =
		{
		{"INSERT INTO trackvoodoo.carmodifications (carRef, name, description, cost) VALUES (?,?,?,?)"},
		{"1","Strut bar","Engine strut bar","100.00"},
		{"2","Suspension","Gaz Gold shocks","500.00"},
		{"2","Slicks","R888's","100.00"}
		};

	
	public static String[][]BOOKEDTRACKDAYS_INJECT =
		{
		{"INSERT INTO trackvoodoo.usertrackdays (trackRef, date, userRef, complete, carRef) VALUES (?,CURDATE(),?,?,?)"},
		{"1","2","False","2"},
		{"3","2","False","1"},
		{"2","3","True","0"}
		};
	
	public static String[][]ACHIVEMENTS_GAINED = 
		{
		{"INSERT INTO trackvoodoo.userpoints (userRef, achivementId, complete, currentPoints, dataComplete) VALUES (?,?,?,?, CURDATE())"},
		{"2","1","1","0"},
		{"2","4","0","10"}
		};
}

